文章目录
闲来无事美化一下以前做的单元格,把二维单元格弄成有立体感的,怎么样?这么做它看起来就像是一个小小的数字键盘,我们如果给它加上超链接,这些单元格就变成一个个按钮。好吧,看看具体的教程:
- 先填写数据,如图所示,我把单元格的大小也调整了一下,有数字的单元格宽和高都更大,这样可以突出显示
![Excel2013:[40]美化单元格立体来点立体感](/2016/05/03/Excel2013%EF%BC%9A%5B40%5D%E7%BE%8E%E5%8C%96%E5%8D%95%E5%85%83%E6%A0%BC%E7%AB%8B%E4%BD%93%E6%9D%A5%E7%82%B9%E7%AB%8B%E4%BD%93%E6%84%9F/8474fbdde71190ef5afa99b8cc1b9d16fdfa6010.jpg)
- 上一点背景色,淡淡的灰色
![Excel2013:[40]美化单元格立体来点立体感](/2016/05/03/Excel2013%EF%BC%9A%5B40%5D%E7%BE%8E%E5%8C%96%E5%8D%95%E5%85%83%E6%A0%BC%E7%AB%8B%E4%BD%93%E6%9D%A5%E7%82%B9%E7%AB%8B%E4%BD%93%E6%84%9F/ac0acf1373f08202c842995849fbfbedaa641b41.jpg)
- 选中有数字的单元格,设置对齐方式为居中对齐
![Excel2013:[40]美化单元格立体来点立体感](/2016/05/03/Excel2013%EF%BC%9A%5B40%5D%E7%BE%8E%E5%8C%96%E5%8D%95%E5%85%83%E6%A0%BC%E7%AB%8B%E4%BD%93%E6%9D%A5%E7%82%B9%E7%AB%8B%E4%BD%93%E6%84%9F/4abae5edab64034fe01dca61adc379310b551d41.jpg)
- 还是选中这些有数字的单元格
![Excel2013:[40]美化单元格立体来点立体感](/2016/05/03/Excel2013%EF%BC%9A%5B40%5D%E7%BE%8E%E5%8C%96%E5%8D%95%E5%85%83%E6%A0%BC%E7%AB%8B%E4%BD%93%E6%9D%A5%E7%82%B9%E7%AB%8B%E4%BD%93%E6%84%9F/42e89c26cffc1e172e6f84564890f603728de942.jpg)
- 打开格式对话框
![Excel2013:[40]美化单元格立体来点立体感](/2016/05/03/Excel2013%EF%BC%9A%5B40%5D%E7%BE%8E%E5%8C%96%E5%8D%95%E5%85%83%E6%A0%BC%E7%AB%8B%E4%BD%93%E6%9D%A5%E7%82%B9%E7%AB%8B%E4%BD%93%E6%84%9F/8bc3a7014a90f603db6094203b12b31bb151ed42.jpg)
- 切换到边框选项下
![Excel2013:[40]美化单元格立体来点立体感](/2016/05/03/Excel2013%EF%BC%9A%5B40%5D%E7%BE%8E%E5%8C%96%E5%8D%95%E5%85%83%E6%A0%BC%E7%AB%8B%E4%BD%93%E6%9D%A5%E7%82%B9%E7%AB%8B%E4%BD%93%E6%84%9F/dc15484e9258d109f4e2a2d5d358ccbf6c814d10.jpg)
- 我们来先设置线型和颜色,线性为粗线,颜色为白色或者浅灰色
![Excel2013:[40]美化单元格立体来点立体感](/2016/05/03/Excel2013%EF%BC%9A%5B40%5D%E7%BE%8E%E5%8C%96%E5%8D%95%E5%85%83%E6%A0%BC%E7%AB%8B%E4%BD%93%E6%9D%A5%E7%82%B9%E7%AB%8B%E4%BD%93%E6%84%9F/dbf554ed2e738bd407f1ba56a38b87d6267ff942.jpg)
- 绘制上边框和左边框
![Excel2013:[40]美化单元格立体来点立体感](/2016/05/03/Excel2013%EF%BC%9A%5B40%5D%E7%BE%8E%E5%8C%96%E5%8D%95%E5%85%83%E6%A0%BC%E7%AB%8B%E4%BD%93%E6%9D%A5%E7%82%B9%E7%AB%8B%E4%BD%93%E6%84%9F/1899a23eb13533fad3b79849aad3fd1f41345b10.jpg)
- 接着设置颜色为黑色,线型不变
![Excel2013:[40]美化单元格立体来点立体感](/2016/05/03/Excel2013%EF%BC%9A%5B40%5D%E7%BE%8E%E5%8C%96%E5%8D%95%E5%85%83%E6%A0%BC%E7%AB%8B%E4%BD%93%E6%9D%A5%E7%82%B9%E7%AB%8B%E4%BD%93%E6%84%9F/fc5e5f34970a304e7d23ab9dd3c8a786c9175c10.jpg)
- 绘制下边框和右边框,点击确定按钮
![Excel2013:[40]美化单元格立体来点立体感](/2016/05/03/Excel2013%EF%BC%9A%5B40%5D%E7%BE%8E%E5%8C%96%E5%8D%95%E5%85%83%E6%A0%BC%E7%AB%8B%E4%BD%93%E6%9D%A5%E7%82%B9%E7%AB%8B%E4%BD%93%E6%84%9F/245e8bcad1c8a786952b41696509c93d70cf5010.jpg)
- 看一下,立体感是不是出来了。
![Excel2013:[40]美化单元格立体来点立体感](/2016/05/03/Excel2013%EF%BC%9A%5B40%5D%E7%BE%8E%E5%8C%96%E5%8D%95%E5%85%83%E6%A0%BC%E7%AB%8B%E4%BD%93%E6%9D%A5%E7%82%B9%E7%AB%8B%E4%BD%93%E6%84%9F/d019d2bf6c81800a54e48269b33533fa828b4710.jpg)
转载请注明来自DataScience.
邮箱: 675495787@qq.com